#!/usr/bin/python

import sqlite3
from log import *

logger=logger("mainModule.test")

try:
	conn = sqlite3.connect('test.db')
	# print "Opened database successfully";
	c = conn.cursor()
	c.execute('''CREATE TABLE goods
	       (ID INT PRIMARY KEY     NOT NULL,
	       itemCode           TEXT    NOT NULL,
	       itemName            TEXT     NOT NULL,
	       remark TEXT);''')
except:
	pass
logger.info("Table created successfully")
# print "...end";

conn.commit()
conn.close()